<%@ page language="java" contentType="text/html; charset=utf-8" %>
<%@ page import="com.alibaba.fastjson.JSONObject" %>
<%@ page import="weaver.general.Util" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page"/>
<jsp:useBean id="bb" class="weaver.general.BaseBean"/>
<%
    String gcxm = Util.null2String( request.getParameter( "gcxm" ) );
    JSONObject jsonData = new JSONObject();
    String sql = "select id,to_char(xmjl)xmjl,to_char(swjl)swjl from uf_CRM_BIDDING_LIB where id=?";
    String msg = "";
    boolean flag = true;
    try{
        rs.executeQuery( sql, gcxm );
        if(rs.next()){
            String xmjl = Util.null2String( rs.getString("xmjl") );
            String swjl = Util.null2String( rs.getString("swjl") );
            if("".equals(xmjl) && "".equals(swjl)){
                msg = "商务经理、项目经理为空，请提交：项目经理/商务经理更新流程进行调整";
                flag = false;
            }else if("".equals(xmjl) && !"".equals(swjl)){
                msg = "项目经理为空，请提交：项目经理/商务经理更新 流程进行调整";
                flag = false;
            }else if(!"".equals(xmjl) && "".equals(swjl)){
                msg = "商务经理为空，请提交：项目经理/商务经理更新 流程进行调整";
                flag = false;
            }
        }
    }catch (Exception e){
        msg = "sql异常";
        flag = false;
        e.printStackTrace();
    }
    jsonData.put( "flag", flag);
    jsonData.put( "msg", msg);
    out.print( jsonData.toJSONString() );
    bb.writeLog( "getXmjl&Swjl_Ajax=" + jsonData.toJSONString() );
%>


